.. _`Unpivot Table`:

.. _`org.sysess.sympathy.data.table.unpivottablenode`:

Unpivot Table
`````````````

.. image:: pivot_table.svg
   :width: 48







Documentation
:::::::::::::

Unpivot a Table.

The inverse operation of Pivot Table. The operation transforms data from a
wide to a narrow format. The wide form can be considered as a matrix of
column values, while the narrow form is a natural encoding of a sparse
matrix. When the data types of value columns differ, the varying data is
converted to a common data type so the source data can be part of one
single column in the new data set.


Definition
::::::::::


Input ports
...........

    **Input**  table
        Input Table


Output ports
............

    **Output**  table
        Output Table




Configuration
.............

    **Index column** (index)
        Column that contains a unique identifier for each row







Examples
........

* :download:`PivotTable.syx </Examples/Sympathy/Data Processing/Structure/PivotTable.syx>`




Implementation
..............

.. automodule:: node_unpivot_table
    :noindex:

.. class:: UnpivotTable
    :noindex: